IF EXISTS (SELECT * FROM sysobjects WHERE type = 'U' AND name = 'ROLE')
BEGIN
    DROP TABLE [dbo].[ROLE]
END

GO

CREATE TABLE [dbo].[ROLE] ( 
	[ID]			INT IDENTITY(1,1)   NOT FOR REPLICATION     NOT NULL,
	[SHORT_NAME]    VARCHAR(25)         NOT NULL	UNIQUE,
	[DESCRIPTION]   VARCHAR(256)

    CONSTRAINT [PK_ROLE_ID] PRIMARY KEY CLUSTERED ( 
        [ID] 
    ) ON [PRIMARY]
    
) ON [PRIMARY] 

CREATE INDEX [IDX_ROLE_SHORT_NAME] on [dbo].[ROLE] ([SHORT_NAME]) 

GO